Dataset info
| Number of variables | 27 |
|---|---|
| Number of observations | 904719 |
| Missing cells | 1718409 (7.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 180.3 MiB |
| Average record size in memory | 209.0 B |
Variables types
| Numeric | 3 |
|---|---|
| Categorical | 20 |
| Boolean | 1 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 3 |
| Unsupported | 0 |
Warnings
AGE_AT_INCIDENT has 17557 (1.9%) missing values | Missing |
AOIC has a high cardinality: 2331 distinct values | Warning |
ARRAIGNMENT_DATE has a high cardinality: 2473 distinct values | Warning |
ARRAIGNMENT_DATE has 127086 (14.0%) missing values | Missing |
ARREST_DATE has a high cardinality: 269479 distinct values | Warning |
ARREST_DATE has 30683 (3.4%) missing values | Missing |
CASE_PARTICIPANT_ID is highly correlated with CASE_ID (ρ = 0.9997263254) | Rejected |
CHARGE_ID is highly correlated with CASE_PARTICIPANT_ID (ρ = 0.9922534959) | Rejected |
CHARGE_OFFENSE_TITLE has a high cardinality: 1402 distinct values | Warning |
CHARGE_VERSION_ID is highly correlated with CHARGE_ID (ρ = 0.9999812286) | Rejected |
EVENT has 21355 (2.4%) missing values | Missing |
EVENT_DATE has a high cardinality: 2577 distinct values | Warning |
EVENT_DATE has 21355 (2.4%) missing values | Missing |
INCIDENT_BEGIN_DATE has a high cardinality: 4505 distinct values | Warning |
INCIDENT_BEGIN_DATE has 11553 (1.3%) missing values | Missing |
INCIDENT_CITY has a high cardinality: 273 distinct values | Warning |
INCIDENT_CITY has 34905 (3.9%) missing values | Missing |
INCIDENT_END_DATE has a high cardinality: 3792 distinct values | Warning |
INCIDENT_END_DATE has 806298 (89.1%) missing values | Missing |
LAW_ENFORCEMENT_AGENCY has a high cardinality: 303 distinct values | Warning |
OFFENSE_CATEGORY has a high cardinality: 87 distinct values | Warning |
RECEIVED_DATE only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
RECEIVED_DATE has a high cardinality: 3258 distinct values | Warning |
SECTION has a high cardinality: 1392 distinct values | Warning |
UNIT has a high cardinality: 98 distinct values | Warning |
UNIT has 633918 (70.1%) missing values | Missing |
UPDATED_OFFENSE_CATEGORY has a high cardinality: 81 distinct values | Warning |
ACT
Categorical
| Distinct count | 49 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | < 0.1% |
| Missing (n) | 8 |
| 5 | |
|---|---|
| 570 | |
| 550 | 25975 |
| Other values (45) | 15097 |
| Value | Count | Frequency (%) | |
| 5 | 692043 | 76.5% | |
| 570 | 171596 | 19.0% | |
| 550 | 25975 | 2.9% | |
| 150 | 4325 | 0.5% | |
| 335 | 2428 | 0.3% | |
| 65 | 2330 | 0.3% | |
| 646 | 2016 | 0.2% | |
| 250 | 1002 | 0.1% | |
| 120 | 722 | 0.1% | |
| 154 | 543 | 0.1% | |
| Other values (38) | 1731 | 0.2% |
| Max length | 4 |
|---|---|
| Mean length | 1.466991408 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
AGE_AT_INCIDENT
Numeric
| Distinct count | 91 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 1.9% |
| Missing (n) | 17557 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 31.9861908 |
|---|---|
| Minimum | 17 |
| Maximum | 156 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 17 |
|---|---|
| 5-th percentile | 18 |
| Q1 | 22 |
| Median | 29 |
| Q3 | 39 |
| 95-th percentile | 55 |
| Maximum | 156 |
| Range | 139 |
| Interquartile range | 17 |
Descriptive statistics
| Standard deviation | 11.72911547 |
|---|---|
| Coef of variation | 0.3666931002 |
| Kurtosis | 0.2151181959 |
| Mean | 31.9861908 |
| MAD | 9.613647886 |
| Skewness | 0.9101415011 |
| Sum | 28376933 |
| Variance | 137.5721496 |
| Memory size | 6.9 MiB |
| Value | Count | Frequency (%) | |
| 19 | 47329 | 5.2% | |
| 20 | 47322 | 5.2% | |
| 21 | 42632 | 4.7% | |
| 22 | 40684 | 4.5% | |
| 23 | 40422 | 4.5% | |
| 24 | 38527 | 4.3% | |
| 25 | 34601 | 3.8% | |
| 26 | 33841 | 3.7% | |
| 18 | 33089 | 3.7% | |
| 27 | 31721 | 3.5% | |
| Other values (80) | 496994 | 54.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 17 | 12569 | 1.4% | |
| 18 | 33089 | 3.7% | |
| 19 | 47329 | 5.2% | |
| 20 | 47322 | 5.2% | |
| 21 | 42632 | 4.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 156 | 1 | < 0.1% | |
| 137 | 2 | < 0.1% | |
| 130 | 1 | < 0.1% | |
| 127 | 2 | < 0.1% | |
| 125 | 1 | < 0.1% |
AOIC
Categorical
| Distinct count | 2331 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 5101110 | 94941 |
|---|---|
| 0012476 | 28227 |
| 0735000 | 28069 |
| Other values (2328) |
| Value | Count | Frequency (%) | |
| 5101110 | 94941 | 10.5% | |
| 0012476 | 28227 | 3.1% | |
| 0735000 | 28069 | 3.1% | |
| 0014717 | 24369 | 2.7% | |
| 0016108 | 23707 | 2.6% | |
| 0012309 | 22459 | 2.5% | |
| 5097200 | 20628 | 2.3% | |
| 0014716 | 17895 | 2.0% | |
| 0014056 | 17677 | 2.0% | |
| 0012474 | 16332 | 1.8% | |
| Other values (2321) | 610415 | 67.5% |
| Max length | 10 |
|---|---|
| Mean length | 7.000704086 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
ARRAIGNMENT_DATE
Categorical
| Distinct count | 2473 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 14.0% |
| Missing (n) | 127086 |
| 6/28/2016 12:00:00 AM | 1615 |
|---|---|
| 2/3/2015 12:00:00 AM | 1005 |
| 3/20/2014 12:00:00 AM | 987 |
| Other values (2469) | |
| (Missing) | 127086 |
| Value | Count | Frequency (%) | |
| 6/28/2016 12:00:00 AM | 1615 | 0.2% | |
| 2/3/2015 12:00:00 AM | 1005 | 0.1% | |
| 3/20/2014 12:00:00 AM | 987 | 0.1% | |
| 12/6/2011 12:00:00 AM | 965 | 0.1% | |
| 2/14/2012 12:00:00 AM | 933 | 0.1% | |
| 1/4/2016 12:00:00 AM | 923 | 0.1% | |
| 9/3/2013 12:00:00 AM | 920 | 0.1% | |
| 1/3/2017 12:00:00 AM | 882 | 0.1% | |
| 11/6/2018 12:00:00 AM | 864 | 0.1% | |
| 7/30/2013 12:00:00 AM | 837 | 0.1% | |
| Other values (2462) | 767702 | 84.9% | |
| (Missing) | 127086 | 14.0% |
| Max length | 22 |
|---|---|
| Mean length | 18.42302527 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
ARREST_DATE
Categorical
| Distinct count | 269479 |
|---|---|
| Unique (%) | 29.8% |
| Missing (%) | 3.4% |
| Missing (n) | 30683 |
| 5/18/2016 8:15:00 PM | 668 |
|---|---|
| 3/28/2017 8:20:00 AM | 495 |
| 5/19/2016 2:40:00 AM | 493 |
| Other values (269475) | |
| (Missing) | 30683 |
| Value | Count | Frequency (%) | |
| 5/18/2016 8:15:00 PM | 668 | 0.1% | |
| 3/28/2017 8:20:00 AM | 495 | 0.1% | |
| 5/19/2016 2:40:00 AM | 493 | 0.1% | |
| 12/22/2014 10:49:00 AM | 422 | < 0.1% | |
| 9/28/2018 3:14:00 PM | 370 | < 0.1% | |
| 8/20/2014 9:33:00 AM | 354 | < 0.1% | |
| 2/26/2011 5:35:00 PM | 342 | < 0.1% | |
| 3/10/2012 1:49:00 AM | 326 | < 0.1% | |
| 3/1/2013 11:55:00 AM | 294 | < 0.1% | |
| 1/25/2012 10:40:00 AM | 287 | < 0.1% | |
| Other values (269468) | 869985 | 96.2% | |
| (Missing) | 30683 | 3.4% |
| Max length | 22 |
|---|---|
| Mean length | 19.66057417 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
CASE_ID
Numeric
| Distinct count | 310135 |
|---|---|
| Unique (%) | 34.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.22620192e+11 |
|---|---|
| Minimum | 6.499985167e+10 |
| Maximum | 1.312340918e+11 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 6.499985167e+10 |
|---|---|
| 5-th percentile | 1.15026065e+11 |
| Q1 | 1.183591503e+11 |
| Median | 1.227271446e+11 |
| Q3 | 1.268397286e+11 |
| 95-th percentile | 1.301468348e+11 |
| Maximum | 1.312340918e+11 |
| Range | 6.623424009e+10 |
| Interquartile range | 8480578272 |
Descriptive statistics
| Standard deviation | 4914641069 |
|---|---|
| Coef of variation | 0.0400801939 |
| Kurtosis | 1.109886342 |
| Mean | 1.22620192e+11 |
| MAD | 4237424801 |
| Skewness | -0.227589411 |
| Sum | 1.109368175e+17 |
| Variance | 2.415369684e+19 |
| Memory size | 6.9 MiB |
| Value | Count | Frequency (%) | |
| 1.250925484e+11 | 1161 | 0.1% | |
| 1.158186255e+11 | 430 | < 0.1% | |
| 1.224934163e+11 | 422 | < 0.1% | |
| 1.261964064e+11 | 400 | < 0.1% | |
| 1.260527791e+11 | 393 | < 0.1% | |
| 1.207425129e+11 | 360 | < 0.1% | |
| 1.218337121e+11 | 354 | < 0.1% | |
| 1.244002554e+11 | 351 | < 0.1% | |
| 1.144393396e+11 | 342 | < 0.1% | |
| 1.194551677e+11 | 327 | < 0.1% | |
| Other values (310125) | 900179 | 99.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 6.499985167e+10 | 105 | < 0.1% | |
| 6.66437026e+10 | 8 | < 0.1% | |
| 7.066412684e+10 | 2 | < 0.1% | |
| 7.160552267e+10 | 1 | < 0.1% | |
| 1.140682916e+11 | 8 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.312340918e+11 | 2 | < 0.1% | |
| 1.31234048e+11 | 1 | < 0.1% | |
| 1.312339166e+11 | 1 | < 0.1% | |
| 1.312337851e+11 | 1 | < 0.1% | |
| 1.312337413e+11 | 1 | < 0.1% |
CASE_PARTICIPANT_ID
Highly correlated
This variable is highly correlated with CASE_ID and should be ignored for analysis
| Correlation | 0.9997263254 |
|---|
CHAPTER
Categorical
| Distinct count | 35 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 720 | |
|---|---|
| 625 | 125583 |
| 730 | 10465 |
| Other values (32) | 7306 |
| Value | Count | Frequency (%) | |
| 720 | 761365 | 84.2% | |
| 625 | 125583 | 13.9% | |
| 730 | 10465 | 1.2% | |
| 15 | 2428 | 0.3% | |
| 430 | 2332 | 0.3% | |
| 35 | 995 | 0.1% | |
| 510 | 427 | < 0.1% | |
| 815 | 426 | < 0.1% | |
| 765 | 180 | < 0.1% | |
| 305 | 146 | < 0.1% | |
| Other values (25) | 372 | < 0.1% |
| Max length | 20 |
|---|---|
| Mean length | 2.996214294 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
CHARGE_COUNT
Numeric
| Distinct count | 668 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.426141155 |
|---|---|
| Minimum | 1 |
| Maximum | 668 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 6 |
| 95-th percentile | 21 |
| Maximum | 668 |
| Range | 667 |
| Interquartile range | 5 |
Descriptive statistics
| Standard deviation | 19.57786564 |
|---|---|
| Coef of variation | 3.04659751 |
| Kurtosis | 345.6398913 |
| Mean | 6.426141155 |
| MAD | 6.523871761 |
| Skewness | 15.28861255 |
| Sum | 5813852 |
| Variance | 383.2928232 |
| Memory size | 6.9 MiB |
| Value | Count | Frequency (%) | |
| 1 | 326742 | 36.1% | |
| 2 | 143185 | 15.8% | |
| 3 | 85710 | 9.5% | |
| 4 | 67157 | 7.4% | |
| 5 | 49179 | 5.4% | |
| 6 | 41552 | 4.6% | |
| 7 | 29391 | 3.2% | |
| 8 | 24054 | 2.7% | |
| 9 | 18031 | 2.0% | |
| 10 | 14381 | 1.6% | |
| Other values (658) | 105337 | 11.6% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 326742 | 36.1% | |
| 2 | 143185 | 15.8% | |
| 3 | 85710 | 9.5% | |
| 4 | 67157 | 7.4% | |
| 5 | 49179 | 5.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 668 | 2 | < 0.1% | |
| 667 | 2 | < 0.1% | |
| 666 | 2 | < 0.1% | |
| 665 | 2 | < 0.1% | |
| 664 | 2 | < 0.1% |
CHARGE_ID
Highly correlated
This variable is highly correlated with CASE_PARTICIPANT_ID and should be ignored for analysis
| Correlation | 0.9922534959 |
|---|
CHARGE_OFFENSE_TITLE
Categorical
| Distinct count | 1402 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| AGGRAVATED UNLAWFUL USE OF WEAPON | 114287 |
|---|---|
| POSSESSION OF A CONTROLLED SUBSTANCE | 97320 |
| AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL | 61779 |
| Other values (1399) |
| Value | Count | Frequency (%) | |
| AGGRAVATED UNLAWFUL USE OF WEAPON | 114287 | 12.6% | |
| POSSESSION OF A CONTROLLED SUBSTANCE | 97320 | 10.8% | |
| AGGRAVATED DRIVING UNDER THE INFLUENCE OF ALCOHOL | 61779 | 6.8% | |
| AGGRAVATED BATTERY | 57653 | 6.4% | |
| FELONY DRIVING WHILE DRIVER?S LICENSE, PERMIT, OR PRIVILEGE TO OPERATE A MOTOR VEHICLE IS SUSPENDED OR REVOKED | 43998 | 4.9% | |
| UNLAWFUL USE OR POSSESSION OF A WEAPON BY A FELON | 42372 | 4.7% | |
| [POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/DELIVERY OF A CONTROLLED SUBSTANCE] | 37710 | 4.2% | |
| FIRST DEGREE MURDER | 30395 | 3.4% | |
| RETAIL THEFT | 23821 | 2.6% | |
| [POSSESSION OF CONTROLLED SUBSTANCE WITH INTENT TO DELIVER/ DELIVERY OF A CONTROLLED SUBSTANCE] | 21357 | 2.4% | |
| Other values (1392) | 374027 | 41.3% |
| Max length | 120 |
|---|---|
| Mean length | 39.91095025 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
CHARGE_VERSION_ID
Highly correlated
This variable is highly correlated with CHARGE_ID and should be ignored for analysis
| Correlation | 0.9999812286 |
|---|
CLASS
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 4 | |
|---|---|
| 2 | |
| 3 | |
| Other values (10) |
| Value | Count | Frequency (%) | |
| 4 | 359203 | 39.7% | |
| 2 | 204485 | 22.6% | |
| 3 | 137513 | 15.2% | |
| X | 94734 | 10.5% | |
| 1 | 76322 | 8.4% | |
| M | 30394 | 3.4% | |
| A | 1586 | 0.2% | |
| B | 194 | < 0.1% | |
| C | 119 | < 0.1% | |
| Z | 92 | < 0.1% | |
| Other values (3) | 77 | < 0.1% |
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
EVENT
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 2.4% |
| Missing (n) | 21355 |
| Preliminary Hearing | |
|---|---|
| Indictment | |
| Re-Indictment | 16569 |
| Other values (2) | 12168 |
| (Missing) | 21355 |
| Value | Count | Frequency (%) | |
| Preliminary Hearing | 669029 | 73.9% | |
| Indictment | 185598 | 20.5% | |
| Re-Indictment | 16569 | 1.8% | |
| Direct Indictment | 11983 | 1.3% | |
| Grand Jury | 185 | < 0.1% | |
| (Missing) | 21355 | 2.4% |
| Max length | 19 |
|---|---|
| Mean length | 16.63782235 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
EVENT_DATE
Categorical
| Distinct count | 2577 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 2.4% |
| Missing (n) | 21355 |
| 11/12/2019 12:00:00 AM | 1501 |
|---|---|
| 1/20/2015 12:00:00 AM | 985 |
| 7/12/2011 12:00:00 AM | 903 |
| Other values (2573) | |
| (Missing) | 21355 |
| Value | Count | Frequency (%) | |
| 11/12/2019 12:00:00 AM | 1501 | 0.2% | |
| 1/20/2015 12:00:00 AM | 985 | 0.1% | |
| 7/12/2011 12:00:00 AM | 903 | 0.1% | |
| 2/3/2017 12:00:00 AM | 880 | 0.1% | |
| 8/28/2013 12:00:00 AM | 877 | 0.1% | |
| 9/17/2014 12:00:00 AM | 876 | 0.1% | |
| 11/19/2015 12:00:00 AM | 855 | 0.1% | |
| 11/15/2011 12:00:00 AM | 852 | 0.1% | |
| 12/1/2014 12:00:00 AM | 835 | 0.1% | |
| 4/25/2017 12:00:00 AM | 818 | 0.1% | |
| Other values (2566) | 873982 | 96.6% | |
| (Missing) | 21355 | 2.4% |
| Max length | 22 |
|---|---|
| Mean length | 20.53441787 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
GENDER
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.5% |
| Missing (n) | 4180 |
| Male | |
|---|---|
| Female | 97258 |
| Unknown Gender | 20 |
| Other values (2) | 17 |
| (Missing) | 4180 |
| Value | Count | Frequency (%) | |
| Male | 803244 | 88.8% | |
| Female | 97258 | 10.8% | |
| Unknown Gender | 20 | < 0.1% | |
| Male name, no gender given | 10 | < 0.1% | |
| Unknown | 7 | < 0.1% | |
| (Missing) | 4180 | 0.5% |
| Max length | 26 |
|---|---|
| Mean length | 4.210868789 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
INCIDENT_BEGIN_DATE
Categorical
| Distinct count | 4505 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 1.3% |
| Missing (n) | 11553 |
| 2/2/2016 12:00:00 AM | 1347 |
|---|---|
| 12/17/2016 12:00:00 AM | 988 |
| 1/1/2012 12:00:00 AM | 929 |
| Other values (4501) | |
| (Missing) | 11553 |
| Value | Count | Frequency (%) | |
| 2/2/2016 12:00:00 AM | 1347 | 0.1% | |
| 12/17/2016 12:00:00 AM | 988 | 0.1% | |
| 1/1/2012 12:00:00 AM | 929 | 0.1% | |
| 10/19/2013 12:00:00 AM | 918 | 0.1% | |
| 7/17/2017 12:00:00 AM | 852 | 0.1% | |
| 1/1/2013 12:00:00 AM | 843 | 0.1% | |
| 9/29/2015 12:00:00 AM | 823 | 0.1% | |
| 11/5/2011 12:00:00 AM | 737 | 0.1% | |
| 1/1/2011 12:00:00 AM | 694 | 0.1% | |
| 2/11/2012 12:00:00 AM | 670 | 0.1% | |
| Other values (4494) | 884365 | 97.8% | |
| (Missing) | 11553 | 1.3% |
| Max length | 22 |
|---|---|
| Mean length | 20.69319866 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
INCIDENT_CITY
Categorical
| Distinct count | 273 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 3.9% |
| Missing (n) | 34905 |
| Chicago | |
|---|---|
| Cicero | 13221 |
| Harvey | 9787 |
| Other values (269) | |
| (Missing) | 34905 |
| Value | Count | Frequency (%) | |
| Chicago | 614613 | 67.9% | |
| Cicero | 13221 | 1.5% | |
| Harvey | 9787 | 1.1% | |
| Chicago Heights | 7680 | 0.8% | |
| Calumet City | 7630 | 0.8% | |
| Berwyn | 6608 | 0.7% | |
| Dolton | 6209 | 0.7% | |
| Orland Park | 5779 | 0.6% | |
| Oak Lawn | 5561 | 0.6% | |
| Evanston | 5270 | 0.6% | |
| Other values (262) | 187456 | 20.7% | |
| (Missing) | 34905 | 3.9% |
| Max length | 21 |
|---|---|
| Mean length | 7.60697852 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
INCIDENT_END_DATE
Categorical
| Distinct count | 3792 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 89.1% |
| Missing (n) | 806298 |
| 8/22/2011 12:00:00 AM | 590 |
|---|---|
| 2/28/2013 12:00:00 AM | 462 |
| 1/19/2017 12:00:00 AM | 408 |
| Other values (3788) | 96961 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 8/22/2011 12:00:00 AM | 590 | 0.1% | |
| 2/28/2013 12:00:00 AM | 462 | 0.1% | |
| 1/19/2017 12:00:00 AM | 408 | < 0.1% | |
| 9/30/2015 12:00:00 AM | 345 | < 0.1% | |
| 9/11/2011 12:00:00 AM | 335 | < 0.1% | |
| 10/31/2014 12:00:00 AM | 327 | < 0.1% | |
| 1/31/2007 12:00:00 AM | 287 | < 0.1% | |
| 7/23/2014 12:00:00 AM | 275 | < 0.1% | |
| 2/10/2016 12:00:00 AM | 256 | < 0.1% | |
| 6/30/2011 12:00:00 AM | 254 | < 0.1% | |
| Other values (3781) | 94882 | 10.5% | |
| (Missing) | 806298 | 89.1% |
| Max length | 22 |
|---|---|
| Mean length | 4.954424523 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
LAW_ENFORCEMENT_AGENCY
Categorical
| Distinct count | 303 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.4% |
| Missing (n) | 3712 |
| CHICAGO PD | |
|---|---|
| COOK COUNTY SHERIFF (IL0160000) | 24233 |
| CICERO PD | 13601 |
| Other values (299) |
| Value | Count | Frequency (%) | |
| CHICAGO PD | 604604 | 66.8% | |
| COOK COUNTY SHERIFF (IL0160000) | 24233 | 2.7% | |
| CICERO PD | 13601 | 1.5% | |
| HARVEY PD | 8478 | 0.9% | |
| CHICAGO HEIGHTS PD | 7906 | 0.9% | |
| CALUMET CITY PD | 7249 | 0.8% | |
| ISP DISTRICT CHICAGO | 6600 | 0.7% | |
| BERWYN PD | 6588 | 0.7% | |
| ORLAND PARK PD | 6580 | 0.7% | |
| DOLTON PD | 5777 | 0.6% | |
| Other values (292) | 209391 | 23.1% |
| Max length | 60 |
|---|---|
| Mean length | 11.87566416 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
OFFENSE_CATEGORY
Categorical
| Distinct count | 87 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Narcotics | |
|---|---|
| UUW - Unlawful Use of Weapon | |
| Aggravated DUI | 56761 |
| Other values (84) |
| Value | Count | Frequency (%) | |
| Narcotics | 190542 | 21.1% | |
| UUW - Unlawful Use of Weapon | 166621 | 18.4% | |
| Aggravated DUI | 56761 | 6.3% | |
| Sex Crimes | 47812 | 5.3% | |
| Homicide | 43345 | 4.8% | |
| Driving With Suspended Or Revoked License | 35736 | 3.9% | |
| Armed Robbery | 29725 | 3.3% | |
| Aggravated Battery Police Officer | 26920 | 3.0% | |
| Retail Theft | 24302 | 2.7% | |
| Aggravated Battery | 20299 | 2.2% | |
| Other values (77) | 262656 | 29.0% |
| Max length | 45 |
|---|---|
| Mean length | 17.27411495 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
PRIMARY_CHARGE
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) | |
| False | 577977 | 63.9% | |
| True | 326742 | 36.1% |
RACE
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.6% |
| Missing (n) | 5791 |
| Black | |
|---|---|
| White [Hispanic or Latino] | |
| White | 116238 |
| Other values (9) | 24407 |
| Value | Count | Frequency (%) | |
| Black | 601981 | 66.5% | |
| White [Hispanic or Latino] | 156302 | 17.3% | |
| White | 116238 | 12.8% | |
| HISPANIC | 11126 | 1.2% | |
| Asian | 6492 | 0.7% | |
| White/Black [Hispanic or Latino] | 4692 | 0.5% | |
| Unknown | 1549 | 0.2% | |
| American Indian | 429 | < 0.1% | |
| Biracial | 111 | < 0.1% | |
| ASIAN | 6 | < 0.1% | |
| Other values (2) | 2 | < 0.1% | |
| (Missing) | 5791 | 0.6% |
| Max length | 32 |
|---|---|
| Mean length | 8.800680653 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
RECEIVED_DATE
Categorical
| Distinct count | 3258 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 5/19/2016 12:00:00 AM | 1499 |
|---|---|
| 10/21/2013 12:00:00 AM | 995 |
| 12/17/2016 12:00:00 AM | 918 |
| Other values (3255) |
| Value | Count | Frequency (%) | |
| 5/19/2016 12:00:00 AM | 1499 | 0.2% | |
| 10/21/2013 12:00:00 AM | 995 | 0.1% | |
| 12/17/2016 12:00:00 AM | 918 | 0.1% | |
| 10/22/2015 12:00:00 AM | 905 | 0.1% | |
| 10/18/2011 12:00:00 AM | 904 | 0.1% | |
| 8/27/2018 12:00:00 AM | 808 | 0.1% | |
| 8/23/2011 12:00:00 AM | 775 | 0.1% | |
| 1/25/2012 12:00:00 AM | 759 | 0.1% | |
| 9/24/2013 12:00:00 AM | 735 | 0.1% | |
| 12/23/2014 12:00:00 AM | 722 | 0.1% | |
| Other values (3248) | 895699 | 99.0% |
| Max length | 22 |
|---|---|
| Mean length | 20.93898658 |
| Min length | 20 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
SECTION
Categorical
| Distinct count | 1392 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | < 0.1% |
| Missing (n) | 8 |
| 402(c) | 94894 |
|---|---|
| 24-1.6(a)(1) | 88050 |
| 11-501(a) | 61943 |
| Other values (1388) |
| Value | Count | Frequency (%) | |
| 402(c) | 94894 | 10.5% | |
| 24-1.6(a)(1) | 88050 | 9.7% | |
| 11-501(a) | 61943 | 6.8% | |
| 6-303(a) | 46530 | 5.1% | |
| 24-1.1(a) | 42372 | 4.7% | |
| 24-1.6(a)(2) | 37662 | 4.2% | |
| 12-3.05(d)(4) | 23692 | 2.6% | |
| 401(d)(i) | 20608 | 2.3% | |
| 16-25(a)(1) | 19346 | 2.1% | |
| 8-4(a)(720-5/9-1(a)(1)) | 16925 | 1.9% | |
| Other values (1381) | 452689 | 50.0% |
| Max length | 30 |
|---|---|
| Mean length | 9.813814013 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
UNIT
Categorical
| Distinct count | 98 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 70.1% |
| Missing (n) | 633918 |
| District 11 - Harrison | 51987 |
|---|---|
| District 10 - Ogden | 21797 |
| District 15 - Austin | 18829 |
| Other values (94) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| District 11 - Harrison | 51987 | 5.7% | |
| District 10 - Ogden | 21797 | 2.4% | |
| District 15 - Austin | 18829 | 2.1% | |
| District 7 - Englewood | 18240 | 2.0% | |
| District 6 - Gresham | 15448 | 1.7% | |
| District 25 - Grand Central | 14441 | 1.6% | |
| District 5 - Calumet | 12603 | 1.4% | |
| District 9 - Deering | 12433 | 1.4% | |
| District 8 - Chicago Lawn | 12088 | 1.3% | |
| District 4 - South Chicago | 11640 | 1.3% | |
| Other values (87) | 81295 | 9.0% | |
| (Missing) | 633918 | 70.1% |
| Max length | 57 |
|---|---|
| Mean length | 8.981180897 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
UPDATED_OFFENSE_CATEGORY
Categorical
| Distinct count | 81 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Narcotics | |
|---|---|
| UUW - Unlawful Use of Weapon | |
| Aggravated DUI | 70872 |
| Other values (78) |
| Value | Count | Frequency (%) | |
| Narcotics | 198825 | 22.0% | |
| UUW - Unlawful Use of Weapon | 171125 | 18.9% | |
| Aggravated DUI | 70872 | 7.8% | |
| Sex Crimes | 48287 | 5.3% | |
| Homicide | 43668 | 4.8% | |
| Aggravated Battery With A Firearm | 36900 | 4.1% | |
| Driving With Suspended Or Revoked License | 36263 | 4.0% | |
| Armed Robbery | 30529 | 3.4% | |
| Aggravated Battery Police Officer | 28874 | 3.2% | |
| Theft | 24546 | 2.7% | |
| Other values (71) | 214830 | 23.7% |
| Max length | 45 |
|---|---|
| Mean length | 17.76765382 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
First rows
| ACT | AGE_AT_INCIDENT | AOIC | ARRAIGNMENT_DATE | ARREST_DATE | CASE_ID | CASE_PARTICIPANT_ID | CHAPTER | CHARGE_COUNT | CHARGE_ID | CHARGE_OFFENSE_TITLE | CHARGE_VERSION_ID | CLASS | EVENT | EVENT_DATE | GENDER | INCIDENT_BEGIN_DATE | INCIDENT_CITY | INCIDENT_END_DATE | LAW_ENFORCEMENT_AGENCY | OFFENSE_CATEGORY | PRIMARY_CHARGE | RACE | RECEIVED_DATE | SECTION | UNIT | UPDATED_OFFENSE_CATEGORY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 5 | 22.0 | 0735100 | 7/11/2011 12:00:00 AM | 5/22/2011 6:51:00 PM | 64999851671 | 260122253823 | 720 | 2 | 2037067609997 | FIRST DEGREE MURDER | 462725085037 | M | Preliminary Hearing | 6/20/2011 12:00:00 AM | Male | 3/12/2007 12:00:00 AM | NaN | NaN | PROMIS Data Conversion | PROMIS Conversion | False | Black | 5/24/2011 12:00:00 AM | 9-1(a)(2) | NaN | Homicide |
| 1 | 5 | 22.0 | 0735200 | 7/11/2011 12:00:00 AM | 5/22/2011 6:51:00 PM | 64999851671 | 260122253823 | 720 | 3 | 2037073820980 | FIRST DEGREE MURDER | 462726494735 | M | Preliminary Hearing | 6/20/2011 12:00:00 AM | Male | 3/12/2007 12:00:00 AM | NaN | NaN | PROMIS Data Conversion | PROMIS Conversion | False | Black | 5/24/2011 12:00:00 AM | 9-1(a)(3) | NaN | Homicide |
| 2 | 5 | 22.0 | 0735200 | 7/11/2011 12:00:00 AM | 5/22/2011 6:51:00 PM | 64999851671 | 260122253823 | 720 | 4 | 2037079144680 | FIRST DEGREE MURDER | 462727770177 | M | Preliminary Hearing | 6/20/2011 12:00:00 AM | Male | 3/12/2007 12:00:00 AM | NaN | NaN | PROMIS Data Conversion | PROMIS Conversion | False | Black | 5/24/2011 12:00:00 AM | 9-1(a)(3) | NaN | Homicide |
| 3 | 5 | 22.0 | 0735200 | 7/11/2011 12:00:00 AM | 5/22/2011 6:51:00 PM | 64999851671 | 260122253823 | 720 | 5 | 2037080919246 | FIRST DEGREE MURDER | 462728172948 | M | Preliminary Hearing | 6/20/2011 12:00:00 AM | Male | 3/12/2007 12:00:00 AM | NaN | NaN | PROMIS Data Conversion | PROMIS Conversion | False | Black | 5/24/2011 12:00:00 AM | 9-1(a)(3) | NaN | Homicide |
| 4 | 5 | 22.0 | 0735200 | 7/11/2011 12:00:00 AM | 5/22/2011 6:51:00 PM | 64999851671 | 260122253823 | 720 | 6 | 2037084172619 | FIRST DEGREE MURDER | 462728911361 | M | Preliminary Hearing | 6/20/2011 12:00:00 AM | Male | 3/12/2007 12:00:00 AM | NaN | NaN | PROMIS Data Conversion | PROMIS Conversion | False | Black | 5/24/2011 12:00:00 AM | 9-1(a)(3) | NaN | Homicide |
| 5 | 5 | 22.0 | 0735200 | 7/11/2011 12:00:00 AM | 5/22/2011 6:51:00 PM | 64999851671 | 260122253823 | 720 | 7 | 2037085059902 | FIRST DEGREE MURDER | 462729112747 | M | Preliminary Hearing | 6/20/2011 12:00:00 AM | Male | 3/12/2007 12:00:00 AM | NaN | NaN | PROMIS Data Conversion | PROMIS Conversion | False | Black | 5/24/2011 12:00:00 AM | 9-1(a)(3) | NaN | Homicide |
| 6 | 5 | 22.0 | 0735200 | 7/11/2011 12:00:00 AM | 5/22/2011 6:51:00 PM | 64999851671 | 260122253823 | 720 | 8 | 2037086242946 | FIRST DEGREE MURDER | 462729381261 | M | Preliminary Hearing | 6/20/2011 12:00:00 AM | Male | 3/12/2007 12:00:00 AM | NaN | NaN | PROMIS Data Conversion | PROMIS Conversion | False | Black | 5/24/2011 12:00:00 AM | 9-1(a)(3) | NaN | Homicide |
| 7 | 5 | 22.0 | 0735200 | 7/11/2011 12:00:00 AM | 5/22/2011 6:51:00 PM | 64999851671 | 260122253823 | 720 | 9 | 2037087425991 | FIRST DEGREE MURDER | 462729649775 | M | Preliminary Hearing | 6/20/2011 12:00:00 AM | Male | 3/12/2007 12:00:00 AM | NaN | NaN | PROMIS Data Conversion | PROMIS Conversion | False | Black | 5/24/2011 12:00:00 AM | 9-1(a)(3) | NaN | Homicide |
| 8 | 5 | 22.0 | 0735200 | 7/11/2011 12:00:00 AM | 5/22/2011 6:51:00 PM | 64999851671 | 260122253823 | 720 | 10 | 2037088313274 | FIRST DEGREE MURDER | 462729851160 | M | Preliminary Hearing | 6/20/2011 12:00:00 AM | Male | 3/12/2007 12:00:00 AM | NaN | NaN | PROMIS Data Conversion | PROMIS Conversion | False | Black | 5/24/2011 12:00:00 AM | 9-1(a)(3) | NaN | Homicide |
| 9 | 5 | 22.0 | 0735200 | 7/11/2011 12:00:00 AM | 5/22/2011 6:51:00 PM | 64999851671 | 260122253823 | 720 | 11 | 2037089200557 | FIRST DEGREE MURDER | 462730052545 | M | Preliminary Hearing | 6/20/2011 12:00:00 AM | Male | 3/12/2007 12:00:00 AM | NaN | NaN | PROMIS Data Conversion | PROMIS Conversion | False | Black | 5/24/2011 12:00:00 AM | 9-1(a)(3) | NaN | Homicide |
Last rows
| ACT | AGE_AT_INCIDENT | AOIC | ARRAIGNMENT_DATE | ARREST_DATE | CASE_ID | CASE_PARTICIPANT_ID | CHAPTER | CHARGE_COUNT | CHARGE_ID | CHARGE_OFFENSE_TITLE | CHARGE_VERSION_ID | CLASS | EVENT | EVENT_DATE | GENDER | INCIDENT_BEGIN_DATE | INCIDENT_CITY | INCIDENT_END_DATE | LAW_ENFORCEMENT_AGENCY | OFFENSE_CATEGORY | PRIMARY_CHARGE | RACE | RECEIVED_DATE | SECTION | UNIT | UPDATED_OFFENSE_CATEGORY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 904709 | 5 | 28.0 | 0012474 | NaN | 12/1/2019 3:49:00 PM | 131233522335 | 1101542423116 | 720 | 2 | 2585370245907 | AGGRAVATED UNLAWFUL USE OF WEAPON | 589641702315 | 4 | NaN | NaN | Male | 12/1/2019 12:00:00 AM | Broadview | NaN | BROADVIEW PD | UUW - Unlawful Use of Weapon | False | Black | 12/1/2019 12:00:00 AM | 24-1.6(a)(1) | NaN | UUW - Unlawful Use of Weapon |
| 904710 | 5 | 28.0 | 0012474 | NaN | 12/1/2019 3:49:00 PM | 131233522335 | 1101542423116 | 720 | 1 | 2585369950146 | AGGRAVATED UNLAWFUL USE OF WEAPON | 589641635187 | 4 | NaN | NaN | Male | 12/1/2019 12:00:00 AM | Broadview | NaN | BROADVIEW PD | UUW - Unlawful Use of Weapon | True | Black | 12/1/2019 12:00:00 AM | 24-1.6(a)(1) | NaN | UUW - Unlawful Use of Weapon |
| 904711 | 5 | 27.0 | 0012475 | NaN | 12/1/2019 11:35:00 AM | 131233609939 | 1101543243921 | 720 | 1 | 2585370541668 | AGGRAVATED UNLAWFUL USE OF WEAPON | 589641769444 | 2 | NaN | NaN | Male | 12/1/2019 12:00:00 AM | Chicago | NaN | CHICAGO PD | UUW - Unlawful Use of Weapon | True | Black | 12/1/2019 12:00:00 AM | 24-1.6(a)(1) | NaN | UUW - Unlawful Use of Weapon |
| 904712 | 5 | 44.0 | 0013855 | NaN | 12/1/2019 6:55:00 PM | 131233697543 | 1101544416501 | 720 | 1 | 2585370837429 | ARMED HABITUAL CRIMINAL | 589641836572 | X | NaN | NaN | Male | 12/1/2019 12:00:00 AM | Chicago | NaN | CHICAGO PD | UUW - Unlawful Use of Weapon | True | Black | 12/1/2019 12:00:00 AM | 24-1.7(a) | NaN | UUW - Unlawful Use of Weapon |
| 904713 | 5 | 32.0 | 0017862 | NaN | 12/1/2019 5:59:00 PM | 131233741345 | 1101545002791 | 720 | 1 | 2585371133190 | AGGRAVATED UNLAWFUL USE OF WEAPON | 589641903701 | 4 | NaN | NaN | Male | 12/1/2019 12:00:00 AM | Chicago | NaN | CHICAGO PD | UUW - Unlawful Use of Weapon | True | HISPANIC | 12/1/2019 12:00:00 AM | 24-1.6(a)(1) | NaN | UUW - Unlawful Use of Weapon |
| 904714 | 5 | 29.0 | 1214500 | NaN | 12/1/2019 8:18:00 PM | 131233785148 | 1101545354565 | 720 | 1 | 2585371428951 | UNLAWFUL USE OR POSSESSION OF A WEAPON BY A FELON | 589641970829 | 3 | NaN | NaN | Male | 12/1/2019 12:00:00 AM | Chicago | NaN | CHICAGO PD | UUW - Unlawful Use of Weapon | True | Black | 12/1/2019 12:00:00 AM | 24-1.1(a) | NaN | UUW - Unlawful Use of Weapon |
| 904715 | 5 | 25.0 | 0015296 | NaN | 12/1/2019 6:50:00 PM | 131233916554 | 1101546878918 | 720 | 1 | 2585371724712 | BOARD AIRCRAFT WITH WEAPON | 589642037958 | 4 | NaN | NaN | Male | 12/1/2019 12:00:00 AM | Chicago | NaN | CHICAGO PD | UUW - Unlawful Use of Weapon | True | White | 12/1/2019 12:00:00 AM | 29D-35.1(a) | NaN | UUW - Unlawful Use of Weapon |
| 904716 | 5 | 19.0 | 1100000 | NaN | 12/1/2019 9:37:00 PM | 131234047960 | 1101548872304 | 720 | 1 | 2585372020473 | ROBBERY | 589642105086 | 2 | NaN | NaN | Male | 12/1/2019 12:00:00 AM | Chicago | NaN | CHICAGO PD | Robbery | True | Black | 12/2/2019 12:00:00 AM | 18-1(a) | NaN | Robbery |
| 904717 | 5 | 21.0 | 1115000 | NaN | 12/1/2019 11:25:00 PM | 131234091763 | 1101549575851 | 720 | 2 | 2585372611996 | POSSESSION OF BURGLARY TOOLS | 589642239343 | 4 | NaN | NaN | Male | 12/1/2019 12:00:00 AM | Hoffman Estates | NaN | HOFFMAN ESTATES PD | Burglary | False | White | 12/2/2019 12:00:00 AM | 19-2(a) | NaN | Burglary |
| 904718 | 5 | 21.0 | 1110000 | NaN | 12/1/2019 11:25:00 PM | 131234091763 | 1101549575851 | 720 | 1 | 2585372316235 | ATTEMPT BURGLARY | 589642172215 | 3 | NaN | NaN | Male | 12/1/2019 12:00:00 AM | Hoffman Estates | NaN | HOFFMAN ESTATES PD | Burglary | True | White | 12/2/2019 12:00:00 AM | 8-4(19-1(a)) | NaN | Burglary |